{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["LABORALS ","Manual d'ús","ValLAB","ValLAB_antiga","Vacances","calcul dies"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":12,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"LABORALS ","index":0,"n_rows":71,"n_cols":9,"rows_kept":71,"cut":false,"hidden":false,"merged":[[28,5,28,6],[28,0,28,4],[8,0,8,4],[8,5,8,6],[62,0,62,1],[27,0,27,4],[27,5,27,6],[46,0,46,4],[46,5,46,6],[53,0,53,4],[53,5,53,6],[54,3,55,4],[4,4,4,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[0,1,0,5],[3,3,3,4]]}
["NOM"]
["TIPUS CONTRACTE",null,null,null,null,null,null,null,"(*) Retribucions 2023 actualitzades amb l'increment del 2,5%"]
["DEDICACIÓ",null,{"$f":"IF(ValLAB!L20=3,\"Posar dedicació 35 hores\",IF(ValLAB!L20=4,\"Posar dedicació a temps parcial\",\"TP: posar les hores setmanals de dedicació / TC: posar 35 hores\"))","v":"TP: posar les hores setmanals de dedicació / TC: posar 35 hores"},null,null,"mesos","dies",null,"(*) Actualització Base cotització Màx. i Min. I MEI amb efectes 1 de gener del 2024"]
["INICI VINCULACIÓ",null,null," Periode",null,{"$f":"IF(B5=0,0,SUM(D66))","v":0},{"$f":"IF(B5=0,0,SUM(E66))","v":0},null,"(*) Actualització Increment retributiu 0,5% març 2024 (efectes retroactius 01 gener 2023)"]
["INICI CONTRACTE/PRORROGA",null,null,null,"FI CONTRACTE/PRORROGA",null,"2024-12-31",null,"(*) Actualització Increment retributiu 2% juliol 2024 (efectes retroactius 01 gener 2024)"]
["Grup: ","1900-01-03",null,null,"Nº TRIENNIS GRUP 1"]
["CLT: ",null,null,null,"Nº TRIENNIS GRUP 2,3 o 4"]
["Nº Dies RD",20,null,null,"IMPORT TRIENNIS",null,{"$f":"((G6*ValLAB!F3)+(G7*ValLAB!F4))*(B3/35)*ValLAB!M22","v":0}]
["COST MENSUAL",null,null,null,null,"COST ANUAL"]
["Retribucions:      ",{"$f":"SUM(B11:B14)","v":0},null,null,null,"Retribucions:      ",{"$f":"B10*12","v":0}]
["Sou",{"$f":"(ValLAB!M16)*B3/35*ValLAB!M22","v":0},null,null,null,"Sou",{"$f":"B11*12","v":0}]
["Millora",{"$f":"(ValLAB!N16)*B3/35*ValLAB!M22","v":0},null,null,null,"Millora",{"$f":"B12*12","v":0}]
["Acord mesa",{"$f":"(ValLAB!P16)*B3/35*ValLAB!M22","v":0},null,null,null,"Acord mesa",{"$f":"B13*12","v":0}]
["clt",{"$f":"ValLAB!M18*'LABORALS '!B3/35*ValLAB!M22","v":0},null,null,null,"clt",{"$f":"B14*12","v":0}]
[]
["Prorrata mensual extres",{"$f":"ValLAB!M16*2/12*B3/35*ValLAB!M22","v":0},null,null,null,"Prorrata  extres",{"$f":"SUM(B16*12)","v":0}]
["Prorrata mensual triennis extres",{"$f":"G8*2/12*ValLAB!M22","v":0},null,null,null,"Prorrata triennis extres",{"$f":"SUM(B17*12)","v":0}]
["TOTAL PRORRATA ",{"$f":"SUM(B16:B17)","v":0},null,null,null,"TOTAL PRORRATA",{"$f":"SUM(B18*12)","v":0}]
[]
["Triennis: ",{"$f":"SUM(G8)","v":0},null,null,null,"Triennis: ",{"$f":"B20*12","v":0}]
[]
["TOTAL RETRIB.",{"$f":"SUM(B10+B18+B20)","v":0},null,null,null,"TOTAL RETRIB.",{"$f":"SUM(G10+G18+G20)","v":0}]
["Indemnització RD",{"$f":"(((B10+B18+B20)*12)/365)*B8/12","v":0},null,null,null,"Indemnització RD",{"$f":"B23*12","v":0}]
["Quota patronal",{"$f":"IF(B22>ValLAB!N10,ValLAB!N20*ValLAB!N10,B22*ValLAB!N20)","v":0},null,null,null,"Quota patronal",{"$f":"B24*12","v":0}]
["TOTAL COST",{"$f":"SUM(B22,B24)","v":0},null,null,null,"TOTAL COST",{"$f":"SUM(B25*12)","v":0}]
[null,null,null,null,null,"FONS CONTINGÈNCIA 2 %",{"$f":"IF(ValLAB!L20>2,0,G25*0%)","v":0}]
[null,null,null,null,null,"Cost amb marge",{"$f":"SUM(G25*B48)+G25","v":0}]
["COST PERIODE ACTUAL (PRORROGA)",null,null,null,null,"COST TOTAL VINCULACIÓ"]
[{"$f":"CONCATENATE(B1,\" (\",DAY(B5),\"/\",MONTH(B5),\"/\",YEAR(B5),\"-\",DAY(G5),\"/\",MONTH(G5),\"/\",YEAR(G5),\")\")","v":" (0/1/1900-31/12/2024)"},null,null,null,null,{"$f":"CONCATENATE(B1,\" (\",DAY(B4),\"/\",MONTH(B4),\"/\",YEAR(B4),\"-\",DAY(#REF!),\"/\",MONTH(#REF!),\"/\",YEAR(#REF!),\")\")","v":{"$error":"#REF!"}}]
[null,"ACTUAL","AMB ARROSEGAMENT"]
["Retribucions:",{"$f":"IF(B10=0,0,B10*(D66+(E66/30)))","v":0},null,{"$f":"IF( (D68+E68+D69+E69)=0,0,B31)","v":0},null,"Retribucions:",{"$f":"IF(B10=0,0,B10*(D65+E65/30))","v":0}]
[]
["TOTAL EXTRES:",{"$f":"SUM(B34:B35)","v":0},null,{"$f":"SUM(D34:D35)","v":0},null,"TOTAL EXTRES:",{"$f":"SUM(G34:G35)","v":0}]
["Extra  juny",{"$f":"IF(B18=0,\" \",B18/2*(D66+(E66/30)))","v":" "},null,{"$f":"IF((D68+E68+D69+E69)=0,0,B18/2*(D68+E68/30)+B34)","v":0},null,"Extra  juny",{"$f":"IF(B18=0,0,B18/2*(D65+E65/30))","v":0}]
["Extra desembre",{"$f":"IF(B18=0,\" \",(B18/2)*(D66+E66/30))","v":" "},null,{"$f":"IF((D68+E68+D69+E69)=0,0,B18/2*(D69+E69/30)+B35)","v":0},null,"Extra desembre",{"$f":"IF(B18=0,0,B18/2*(D65+E65/30))","v":0}]
[]
["Triennis: ",{"$f":"IF(B20=0,0,B20*(D66+E66/30))","v":0},null,{"$f":"IF((D68+E68+D69+E69)=0,0,B37)","v":0},null,"Triennis: ",{"$f":"IF(B20=0,0,B20*(D65+E65/30))","v":0}]
[]
["TOTAL RETRIB.",{"$f":"IF(B31=0,0,SUM(B31+B33+B37))","v":0},null,{"$f":"SUM(D31+D33+D37)","v":0},null,"TOTAL RETRIB.",{"$f":"SUM(G31+G33+G37)","v":0}]
["Indemnització RD ",{"$f":"IF(B23=0,0,B23*(D66+E66/30))","v":0},null,{"$f":"IF((D68+E68+D69+E69)=0,0,B23*(D70+E70/30)+B40)","v":0},null,"Indemnització RD ",{"$f":"IF(B125=0,0,B23*(D65+E65/30))","v":0}]
["Quota patronal",{"$f":"IF(B22>ValLAB!N10,B24*(D66+(E66/30)),B39*ValLAB!N20)","v":0},null,{"$f":"IF((D68+E68+D69+E69)=0,0,B41)","v":0},null,"Quota patronal",{"$f":"G39*ValLAB!N20","v":0}]
["TOTAL COST",{"$f":"SUM(B39,B41)","v":0},null,{"$f":"SUM(D39:D41)","v":0},null,"TOTAL COST",{"$f":"SUM(G39:G41)","v":0}]
["FONS CONTINGÈNCIA 2 %",{"$f":"B42*0","v":0}]
["Import L1",{"$f":"B39","v":0},null,{"$f":"SUM(D39+D40)","v":0},null,"Import L1",{"$f":"SUM(G39+G40)","v":0}]
["Import L2",{"$f":"SUM(B41)","v":0},null,{"$f":"SUM(D41)","v":0},null,"Import L2",{"$f":"SUM(G41)","v":0}]
[]
["COST AMB MARGE  PERIODE ACTUAL",null,null,null,null,"Cost amb  marge TOTAL VINCULACIÓ"]
["Marge",0.02]
[null,null,"Amb arrossegament"]
["Import L1",{"$f":"SUM(B44)+(B44*$B$48)","v":0},"Import L1",{"$f":"SUM(D44)+(D44*$B$48)","v":0},null,"Import L1",{"$f":"SUM(G44)+(G44)*$B$48","v":0}]
["Import L2",{"$f":"SUM(B45+B45*$B$48)","v":0}]
["                                    TOTAL    ",{"$f":"SUM(B50:B51)","v":0},"Import L2",{"$f":"SUM(D45+D45*$B$48)","v":0},null,"Import L2",{"$f":"SUM(G45+G45*$B$48)","v":0}]
[]
["Cost amb marge i retallada  PERIODE ACTUAL"]
[null,"Retribucions","Quota patronal"]
["Import aprox.Retallada 2014",{"$f":"(B18/2)*(D71+E71/30)","v":0},{"$f":"(B56*ValLAB!N20)","v":0},null,null,"Retallades anteriors a 2014 "]
[null,"Sense arrossegament",null,"Amb arrossegament"]
["Import L1",{"$f":"SUM(B44-B56)+(B44-B56)*$B$48","v":0},"Import L1",{"$f":"IF((D68+E68+D69+E69)=0,0,(D44-B56)+(D44-B56)*$B$48)","v":0},null,"Import L1",{"$f":"SUM(G44-G56-B56)+(G44-G56-B56)*$B$48","v":0}]
["Import L2",{"$f":"SUM(B45-C56)+(B45-C56)*$B$48","v":0},"Import L2",{"$f":"IF((D68+E68+D69+E69)=0,0,(D45-C56)+(D45-C56)*$B$48)","v":0},null,"Import L2",{"$f":"SUM(G45-C56+(G45-C56)*$B$48)","v":0}]
["TOTAL",{"$f":"SUM(B58:C59)","v":0},"TOTAL",{"$f":"SUM(D58:D59)","v":0},null,"TOTAL AMB RETALLADES",{"$f":"SUM(G58:G59)","v":0}]
["FONS CONTINGÈNCIA",{"$f":"SUM((B44-B56)+(B45))*3%","v":0},"(sense marge)",null,null,"(INCLOSES ANTERIORS 2014)"]
[]
["MERITACIÓ ARROSEGAMENT PAGUES"]
[null,"DATA INICI","DATA FI","Nº MESOS","Nº DIES"]
["TOTAL VINCULACIÓ",{"$f":"IF(B4=0,\" \",B4)","v":" "},{"$f":"IF(G5=0,\" \",G5)","v":"2024-12-31"},{"$f":"IF((C65-B65)>0,'calcul dies'!L5,\"ERROR DATES\")","v":{"$error":"#VALUE!"}},{"$f":"IF((C65-B65)>0,'calcul dies'!N5,\" \")","v":{"$error":"#VALUE!"}}]
["PRORROGA",{"$f":"IF(B5=0,\" \",B5)","v":" "},{"$f":"IF(G5=0,\" \",G5)","v":"2024-12-31"},{"$f":"IF((C66-B66)>0,'calcul dies'!L10,\"ERROR DATES\")","v":{"$error":"#VALUE!"}},{"$f":"IF((C66-B66)>0,'calcul dies'!N10,\" \")","v":{"$error":"#VALUE!"}}]
["MERITEN",null,"DATA FI","NºMESOS","Nº DIES"]
["de 01/07 a 30/06",null,{"$f":"IF(G5=0,\" \",(G5)-1)","v":"2024-12-30"},{"$f":"IF(B68=0,0,IF((C68-B68)>366,\"ERROR DATA\",IF((C68-B68)>0,'calcul dies'!L15,\"ERR0R DATA \")))","v":0},{"$f":"IF(B68=0,0,IF((C68-B68)>366,\" \",IF((C68-B68)>0,'calcul dies'!N15,\" \")))","v":0}]
["de 01/01 a 31/12",null,{"$f":"IF(G5=0,\" \",(G5)-1)","v":"2024-12-30"},{"$f":"IF(B69=0,0,IF((C69-B69)>366,\"ERROR DATA\",IF((C69-B69)>0,'calcul dies'!L20,\"ERR0R DATA \")))","v":0},{"$f":"IF(B69=0,0,IF((C69-B69)>366,\" \",IF((C69-B69)>0,'calcul dies'!N20,\" \")))","v":0}]
["Indemnització RD",null,{"$f":"IF(G5=0,\" \",(G5)-1)","v":"2024-12-30"},{"$f":"IF(B70=0,0,IF((C70-B70)>366,\"ERROR DATA\",IF((C70-B70)>0,'calcul dies'!L25,\"ERR0R DATA \")))","v":0},{"$f":"IF(B70=0,0,IF((C70-B70)>366,\"ERROR DATA\",IF((C70-B70)>0,'calcul dies'!N25,\" \")))","v":0}]
["Període treballat al 2014",null,{"$f":"IF(YEAR(G5)>2014,DATE(2014,12,31),IF(G5<>0,G5,\" \"))","v":"2014-12-31"},{"$f":"IF(B71=0,0,IF((C71-B71)>366,\"ERROR DATA\",IF((C71-B71)>0,'calcul dies'!L30,\"ERR0R DATA \")))","v":0},{"$f":"IF(B71=0,0,IF((C71-B71)>366,\"ERROR DATA\",IF((C71-B71)>0,'calcul dies'!N30,\" \")))","v":0}]

{"sheet":"Manual d'ús","index":1,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[[13,1,13,12],[18,0,18,12],[8,0,8,12],[12,0,12,12]]}
[]
["Què es aquest fitxer?"]
["És un simulador que us permet obtenir la distribució previsible de la despesa d'una contractació."]
[]
["Per a què serveix?"]
["Per a que el personal interessat en iniciar un procediment de contractació pugui preveure els costos de personal d'acord amb les seves necessitats."]
[]
["Com funciona?"]
["Heu d'emplenar els camps en blanc de la zona blava."]
[]
["Quin grup escollir?"]
["El grup depèn de les funcions que desenvolupi el/la treballador/a."]
["A continuació us facilitem un quadre on es recullen les diferents possibilitats de manera resumida:"]
["Grup 1: ","Funcions de Llicenciats/des, Enginyers/es, Arquitectes i Doctors/es."]
["Grup 2: ","Funcions de Diplomats/es, Enginyers/es Tècnics/ques"]
["Grup 3: ","Batxiller, FPII, CFGS. "]
[]
["Quin complement de lloc de treball (CLT) escollir?"]
["El CLT és un dels 3 complements que intervenen en la retribució del personal laboral (sou i millora serien la resta)."]
["A les següents possibilitats podreu triar la que us interessi més:"]
["Grup 1: ","De la U (el mínim) a la A (el màxim)."]
["Grup 2: ","De la U a la D."]
["Grup 3: ","De la U a la K."]

{"sheet":"ValLAB","index":2,"n_rows":268,"n_cols":18,"rows_kept":268,"cut":false,"hidden":true,"merged":[[199,0,226,0],[192,3,192,6],[192,9,192,12],[194,0,194,2],[195,0,195,2],[196,0,196,2],[36,3,36,6],[36,9,36,12],[38,0,38,2],[39,0,39,2],[40,0,40,2],[80,0,107,0],[74,3,74,6],[74,9,74,12],[76,0,76,2],[77,0,77,2],[78,0,78,2],[112,3,112,6],[112,9,112,12],[114,0,114,2],[115,0,115,2],[116,0,116,2],[153,3,153,6],[155,0,155,2],[156,0,156,2],[157,0,157,2],[153,9,153,12],[232,3,232,6],[234,0,234,2],[235,0,235,2],[236,0,236,2],[240,0,267,0]]}
[]
["Grups","Sou mes","Mll mes","Acord mesa","Hores extres","trienni",null,"CLT mes","Centre Liquidació","Valor Seg_ Social","Reduccions",null,"Tipus de contractes","Centre Liq.","% QP","% RETRIB.","Indemnització"]
[1,2534.84,16.86,8.19,11.54,66.45,"A",2829.5,"005-A",0.309,1,null,"LABORAL INDEFINIT","005-A",0.31979999999999997,1,"no","Increment 0,50 març 2024"]
[2,2206.63,16.5,8.19,10.33,55.57,"A0",2629.19,"006-A",0.32100000000000001,0.75,null,"TEMPORAL VINCULAT A PROGRAMES FINANÇATS PER FONS EUROPEUS TC (35h)","006-A",0.33179999999999998,1,"si"]
[3,1930.91,16.850000000000001,8.19,9.1199999999999992,55.57,"A1-no utilitzar",2502.3000000000002,"007-A",0.32100000000000001,0.6,null,"TEMPORAL VINCULAT A PROGRAMES FINANÇATS PER FONS EUROPEUS TP (< 35h)","007-A",0.33179999999999998,1,"si"]
[4,1599.17,16.78,8.19,7.6,55.57,"B",2322.4900000000002,"005-D",0.36599999999999999]
[null,null,null,null,null,null,"B0",2268.13,"006-D",0.38700000000000001]
[null,null,null,null,null,null,"B1 -no utilizar",null,"007-D",0.38800000000000001]
[null,null,null,null,null,null,"C",2041.29,"005-80",0.309]
["JULIOL 2024 INCREMENT 2%",null,null,null,null,null,"C0",1720.95,"006-80",0.32100000000000001,null,null,"Base màx.cotització 2024",4720.5]
[null,null,null,null,null,null,"D",1505.32,"007-80",0.33100000000000002]
[null,null,null,null,null,null,"E",1143.03,"001-A",0.307]
[null,null,null,null,null,null,"F",1100.3599999999999,"002-A",0.252]
["retribucions actualitzades amb l'increment previst 2024",null,null,null,null,null,"G",950.29,null,null,null,"Retribucions"]
[null,null,null,null,null,null,"H",842.93999999999994,null,null,null,"Grup","Sou","Millora","Hora","Acord mesa"]
[null,null,null,null,null,null,"I",739.48,null,null,null,2,{"$f":"CHOOSE(L16,B3,B4,B5,B6)","v":2206.63},{"$f":"CHOOSE(L16,C3,C4,C5,C6)","v":16.5},{"$f":"CHOOSE(L16,E3,E4,E5,E6)","v":10.33},{"$f":"CHOOSE(L16,D3,D4,D5,D6)","v":8.19}]
[null,null,null,null,null,null,"J",628.21,null,null,null,"CLT"]
[null,null,null,null,null,null,"K",507.08,null,null,null,29,{"$f":"INDEX(H3:H32,L18)","v":101.10000000000001}]
[null,null,null,null,null,null,"L",492.77,null,null,null,"Centre de Liquidació-Epígraf",null,"% corresponent"]
[null,null,null,null,null,null,"M",454.05,null,null,null,2,{"$f":"INDEX(N3:N5,L20)","v":"006-A"},{"$f":"INDEX(O3:O5,L20)","v":0.33179999999999998}]
["INDEMNITZACIONS",null,null,null,null,null,"M1-sols PQS",399.88,null,null,null,"Reducció de retribucions (contracte en pràctiques)"]
["INDEFINIT",20,null,null,null,null,"N",370.55,null,null,null,{"$f":"L20","v":2},{"$f":"INDEX(P3:P5,L22)","v":1}]
["TEMPORAL",12,null,null,null,null,"Ñ",350.28]
["FORMATIU",0,null,null,null,null,"O",306.77999999999997]
[null,null,null,null,null,null,"O1-sols PQS"]
[null,null,null,null,null,null,"P",238.23]
[null,null,null,null,null,null,"Q",176.25]
[null,null,null,null,null,null,"R",163.16]
[null,null,null,null,null,null,"S",145.22]
[null,null,null,null,null,null,"T",116.75]
[null,null,null,null,null,null,"U",101.10000000000001]
[null,null,null,null,null,null,"V",47.46]
[]
[]
[2022]
[]
[null,null,null,"Grup",null,null,null,null,null,"Grup"]
[null,null,null,1,2,3,4,null,null,1,2,3,4]
["Sou base",null,null,2366.29,2059.91,1802.51,1492.84,null,"P.Perillositat",238.37,198.67,168.23,128.97999999999999]
["Millora",null,null,15.72,15.39,15.71,15.65,null,"Triennis",62.02,51.87,51.87,51.87]
["Acord Mesa universitats",null,null,7.62,7.62,7.62,7.62,null,"Hores extres",11.54,10.33,9.1199999999999992,7.6]
[]
[]
[null,"A ",2641.36]
[null,"A0",2454.3500000000004]
[null,"A1*",2335.9]
[null,"B ",2168.0700000000002]
[null,"B0",2117.3000000000002]
[null,"C ",1905.56]
[null,"C0",1606.49]
[null,"D ",1405.23]
[null,"E ",1067.02]
[null,"F ",1027.19]
[null,"G ",887.1]
[null,"H ",786.88]
[null,"I ",690.31]
[null,"J ",586.41999999999996]
[null,"K ",473.34999999999997]
[null,"L ",459.99]
[null,"M ",423.84999999999997]
[null,"M1*",373.27]
[null,"N ",345.90999999999997]
[null,"Ñ ",326.99]
[null,"O ",286.37]
[null,"P ",222.38]
[null,"Q ",164.51999999999998]
[null,"R ",152.31]
[null,"S ",135.54999999999998]
[null,"T ",108.98]
[null,"U ",94.37]
[null,"V ",44.28]
[]
[]
["2022-11-01"]
[null,null,null,"Grup",null,null,null,null,null,"Grup"]
[null,null,null,1,2,3,4,null,null,1,2,3,4]
["Sou base",null,null,2401.09,2090.21,1829.02,1514.8,null,"P.Perillositat",241.88,201.6,170.71,130.88]
["Millora",null,null,15.96,15.62,15.95,15.89,null,"Triennis",62.94,52.64,52.64,52.64]
["Acord Mesa universitats",null,null,7.74,7.74,7.74,7.74,null,"Hores extres",11.54,10.33,9.1199999999999992,7.6]
[]
["Complement de lloc de treball","A ",2680.21,null,2747.2152500000002]
[null,"A0",2490.4499999999998,null,2552.7112499999998]
[null,"A1*",2370.2600000000002,null,2429.5165000000002]
[null,"B ",2199.96,null,2254.9589999999998]
[null,"B0",2148.44,null,2202.1509999999998]
[null,"C ",1933.59,null,1981.92975]
[null,"C0",1630.12,null,1670.8729999999998]
[null,"D ",1425.9,null,1461.5475000000001]
[null,"E ",1082.72,null,1109.788]
[null,"F ",1042.3,null,1068.3574999999998]
[null,"G ",900.15,null,922.65374999999995]
[null,"H ",798.46,null,818.42150000000004]
[null,"I ",700.47,null,717.98175000000003]
[null,"J ",595.04999999999995,null,609.92624999999998]
[null,"K ",480.32,null,492.32799999999997]
[null,"L ",466.76,null,478.42899999999997]
[null,"M ",430.09,null,440.84224999999998]
[null,"M1*",378.76,null,388.22899999999998]
[null,"N ",351,null,359.77499999999998]
[null,"Ñ ",331.8,null,340.09500000000003]
[null,"O ",290.58999999999997,null,297.85474999999997]
[null,"P ",225.66,null,231.3015]
[null,"Q ",166.94,null,171.11349999999999]
[null,"R ",154.55000000000001,null,158.41375000000002]
[null,"S ",137.55000000000001,null,140.98875000000001]
[null,"T ",110.59,null,113.35475000000001]
[null,"U ",95.76,null,98.154000000000011]
[null,"V ",44.94,null,46.063499999999998]
[]
[]
[]
["2023-02-01",2.5000000000000001E-2]
[null,null,null,"Grup",null,null,null,null,null,"Grup"]
[null,null,null,1,2,3,4,null,null,1,2,3,4]
["Sou base",null,null,{"$f":"(D77*$B$112)+D77","v":2461.1172500000002},2142.4652500000002,1874.7455,1552.6699999999998,null,"P.Perillositat",{"$f":"(J77*$B$112)+J77","v":247.92699999999999},206.64,174.97775000000001,134.15199999999999]
["Millora",null,null,16.359000000000002,16.0105,16.348749999999999,16.28725,null,"Triennis",64.513499999999993,53.956000000000003,53.956000000000003,53.956000000000003]
["Acord Mesa universitats",null,null,{"$f":"(D79*$B$112)+D79","v":7.9335000000000004},{"$f":"(E79*$B$112)+E79","v":7.9335000000000004},7.9335000000000004,7.9335000000000004,null,"Hores extres",11.54,10.33,9.1199999999999992,7.6]
[]
[]
[null,"A ",{"$f":"(C81*$B$112)+C81","v":2747.2152500000002}]
[null,"A0",{"$f":"(C82*$B$112)+C82","v":2552.7112499999998}]
[null,"A1*",{"$f":"(C83*$B$112)+C83","v":2429.5165000000002}]
[null,"B ",{"$f":"(C84*$B$112)+C84","v":2254.9589999999998}]
[null,"B0",2202.1509999999998]
[null,"C ",1981.92975]
[null,"C0",1670.8729999999998]
[null,"D ",1461.5475000000001]
[null,"E ",1109.788]
[null,"F ",1068.3574999999998]
[null,"G ",922.65374999999995]
[null,"H ",818.42150000000004]
[null,"I ",717.98175000000003]
[null,"J ",609.92624999999998]
[null,"K ",492.32799999999997]
[null,"L ",478.42899999999997]
[null,"M ",440.84224999999998]
[null,"M1*",388.22899999999998]
[null,"N ",359.77499999999998]
[null,"Ñ ",340.09500000000003]
[null,"O ",297.85474999999997]
[null,"P ",231.3015]
[null,"Q ",171.11349999999999]
[null,"R ",158.41375000000002]
[null,"S ",140.98875000000001]
[null,"T ",113.35475000000001]
[null,"U ",98.154000000000011]
[null,"V ",46.063499999999998]
[]
[]
[]
["2023-11-01",5.0000000000000001E-3,"(retroactiu gener-23)"]
[]
[]
[null,null,null,"Grup",null,null,null,null,null,"Grup"]
[null,null,null,1,2,3,4,null,null,1,2,3,4]
["Sou base",null,null,2473.13,2152.91,1883.9,1560.24,null,"P.Perillositat",249.13,207.64,176.15,134.81]
["Millora",null,null,16.440000000000001,16.09,16.43,16.37,null,"Triennis",64.819999999999993,54.21,54.21,54.21]
["Acord Mesa universitats",null,null,7.98,7.98,7.98,7.98,null,"Hores extres",11.54,10.33,9.1199999999999992,7.6]
[]
[]
[null,"A ",2760.62]
[null,"A0",2565.17]
[null,"A1*",2441.3700000000003]
[null,"B ",2265.9499999999998]
[null,"B0",2212.9]
[null,"C ",1991.59]
[null,"C0",1679.04]
[null,"D ",1468.68]
[null,"E ",1115.2]
[null,"F ",1073.57]
[null,"G ",927.15]
[null,"H ",822.42]
[null,"I ",721.48]
[null,"J ",612.91]
[null,"K ",494.72]
[null,"L ",480.77]
[null,"M ",442.99]
[null,"M1*",390.13]
[null,"N ",361.52]
[null,"Ñ ",341.75]
[null,"O ",299.3]
[null,"P ",232.42]
[null,"Q ",171.95]
[null,"R ",159.19]
[null,"S ",141.68]
[null,"T ",113.9]
[null,"U ",98.63]
[null,"V ",46.29]
[]
[]
["2024-03-01",0.5,"(retroactiu gener -24)"]
[]
[null,null,null,"Grup",null,null,null,null,null,"Grup"]
[null,null,null,1,2,3,4,null,null,1,2,3,4]
["Sou base",null,null,2485.13,2163.36,1893.04,1567.81,null,"P.Perillositat",250.34,208.64999999999998,177.01,135.47]
["Millora",null,null,16.520000000000003,16.170000000000002,16.510000000000002,16.450000000000003,null,"Triennis",65.14,54.48,54.48,54.48]
["Acord Mesa universitats",null,null,8.02,8.02,8.02,8.02,null,"Hores extres",11.54,10.33,9.1199999999999992,7.6]
[]
[]
["Complement de lloc de treball","A ",2774.01]
[null,"A0",2577.63]
[null,"A1*",2453.23]
[null,"B ",2276.9500000000003]
[null,"B0",2223.65]
[null,"C ",2001.26]
[null,"C0",1687.2]
[null,"D ",1475.8]
[null,"E ",1120.6099999999999]
[null,"F ",1078.78]
[null,"G ",931.65]
[null,"H ",826.41]
[null,"I ",724.98]
[null,"J ",615.89]
[null,"K ",497.13]
[null,"L ",483.1]
[null,"M ",445.14]
[null,"M1*",392.03]
[null,"N ",363.28]
[null,"Ñ ",343.40999999999997]
[null,"O ",300.76]
[null,"P ",233.54999999999998]
[null,"Q ",172.79]
[null,"R ",159.96]
[null,"S ",142.37]
[null,"T ",114.46000000000001]
[null,"U ",99.11]
[null,"V ",46.519999999999996]
[]
[]
[]
["2024-07-01",2,"(retroactiu gener -24)"]
[]
[null,null,null,"Grup"]
[null,null,null,1,2,3,4]
["Sou base",null,null,2534.84,2206.63,1930.91,1599.17]
["Millora",null,null,16.860000000000003,16.5,16.850000000000001,16.78]
["Acord Mesa universitats",null,null,8.19,8.19,8.19,8.19]
[]
[]
[]
["Complement de lloc de treball","A ",2829.5]
[null,"A0",2629.19]
[null,"A1*",2502.3000000000002]
[null,"B ",2322.4900000000002]
[null,"B0",2268.13]
[null,"C ",2041.29]
[null,"C0",1720.95]
[null,"D ",1505.32]
[null,"E ",1143.03]
[null,"F ",1100.3599999999999]
[null,"G ",950.29]
[null,"H ",842.93999999999994]
[null,"I ",739.48]
[null,"J ",628.21]
[null,"K ",507.08]
[null,"L ",492.77]
[null,"M ",454.05]
[null,"M1*",399.88]
[null,"N ",370.55]
[null,"Ñ ",350.28]
[null,"O ",306.77999999999997]
[null,"P ",238.23]
[null,"Q ",176.25]
[null,"R ",163.16]
[null,"S ",145.22]
[null,"T ",116.75]
[null,"U ",101.10000000000001]
[null,"V ",47.46]

{"sheet":"ValLAB_antiga","index":3,"n_rows":188,"n_cols":17,"rows_kept":188,"cut":false,"hidden":true,"merged":[[156,0,156,2],[157,0,157,2],[114,0,114,2],[115,0,115,2],[116,0,116,2],[153,3,153,6],[153,9,153,12],[155,0,155,2],[76,0,76,2],[77,0,77,2],[78,0,78,2],[80,0,107,0],[112,3,112,6],[112,9,112,12],[74,3,74,6],[74,9,74,12],[36,3,36,6],[36,9,36,12],[38,0,38,2],[39,0,39,2],[40,0,40,2]]}
[]
["Grups","Sou mes","Mll mes","Acord mesa","Hores extres","trienni",null,"CLT mes","Centre Liquidació","Valor Seg_ Social","Reduccions",null,"Tipus de contractes","Centre Liq.","% QP","% RETRIB.","Indemnització"]
[1,2473.13,16.440000000000001,7.98,11.54,64.819999999999993,"A",2760.62,"005-A",0.309,1,null,"LABORAL INDEFINIT","005-A",0.31900000000000001,1,"no"]
[2,2152.91,16.09,7.98,10.33,54.21,"A0",2565.17,"006-A",0.32100000000000001,0.75,null,"TEMPORAL FORMATIU PER A LA PRÀCTICA PROFESSIONAL","005-A",0.31900000000000001,1,"no"]
[3,1883.9,16.43,7.98,9.1199999999999992,54.21,"A1-no utilitzar",2441.3700000000003,"007-A",0.32100000000000001,0.6,null,"TEMPORAL VINCULAT A PROGRAMES FINANÇATS PER FONS EUROPEUS TC (35h)","006-A",0.33100000000000002,1,"si"]
[4,1560.24,16.37,7.98,7.6,54.21,"B",2265.9499999999998,"005-D",0.36599999999999999,null,null,"TEMPORAL VINCULAT A PROGRAMES FINANÇATS PER FONS EUROPEUS TP (< 35h)","007-A",0.33100000000000002,1,"si"]
[null,null,null,null,null,null,"B0",2212.9,"006-D",0.38700000000000001]
[null,null,null,null,null,null,"B1 -no utilizar",null,"007-D",0.38800000000000001]
[null,null,null,null,null,null,"C",1991.59,"005-80",0.309]
[null,null,null,null,null,null,"C0",1679.04,"006-80",0.32100000000000001,null,null,"Base màx.cotizzció 2023",4495.5]
[null,null,null,null,null,null,"D",1468.68,"007-80",0.33100000000000002]
[null,null,null,null,null,null,"E",1115.2,"001-A",0.307]
[null,null,null,null,null,null,"F",1073.57,"002-A",0.252]
["retribucions actualitzades amb l'increment previst 2023 ",null,null,null,null,null,"G",927.15,null,null,null,"Retribucions"]
[null,null,null,null,null,null,"H",822.42,null,null,null,"Grup","Sou","Millora","Hora","Acord mesa"]
[null,null,null,null,null,null,"I",721.48,null,null,null,1,{"$f":"CHOOSE(L16,B3,B4,B5,B6)","v":2473.13},{"$f":"CHOOSE(L16,C3,C4,C5,C6)","v":16.440000000000001},{"$f":"CHOOSE(L16,E3,E4,E5,E6)","v":11.54},{"$f":"CHOOSE(L16,D3,D4,D5,D6)","v":7.98}]
[null,null,null,null,null,null,"J",612.91,null,null,null,"CLT"]
[null,null,null,null,null,null,"K",494.72,null,null,null,29,{"$f":"INDEX(H3:H32,L18)","v":98.63}]
[null,null,null,null,null,null,"L",480.77,null,null,null,"Centre de Liquidació-Epígraf",null,"% corresponent"]
[null,null,null,null,null,null,"M",442.99,null,null,null,4,{"$f":"INDEX(N3:N6,L20)","v":"007-A"},{"$f":"INDEX(O3:O6,L20)","v":0.33100000000000002}]
[null,null,null,null,null,null,"M1-sols PQS",390.13,null,null,null,"Reducció de retribucions (contracte en pràctiques)"]
[null,null,null,null,null,null,"N",361.52,null,null,null,{"$f":"L20","v":4},{"$f":"INDEX(P3:P6,L22)","v":1}]
[null,null,null,null,null,null,"Ñ",341.75]
[null,null,null,null,null,null,"O",299.3]
[null,null,null,null,null,null,"O1-sols PQS"]
[null,null,null,null,null,null,"P",232.42]
[null,null,null,null,null,null,"Q",171.95]
[null,null,null,null,null,null,"R",159.19]
[null,null,null,null,null,null,"S",141.68]
[null,null,null,null,null,null,"T",113.9]
[null,null,null,null,null,null,"U",98.63]
[null,null,null,null,null,null,"V",46.29]
[]
[]
[2022]
[]
[null,null,null,"Grup",null,null,null,null,null,"Grup"]
[null,null,null,1,2,3,4,null,null,1,2,3,4]
["Sou base",null,null,2366.29,2059.91,1802.51,1492.84,null,"P.Perillositat",238.37,198.67,168.23,128.97999999999999]
["Millora",null,null,15.72,15.39,15.71,15.65,null,"Triennis",62.02,51.87,51.87,51.87]
["Acord Mesa universitats",null,null,7.62,7.62,7.62,7.62,null,"Hores extres",11.54,10.33,9.1199999999999992,7.6]
[]
[]
[null,"A ",2641.36]
[null,"A0",2454.3500000000004]
[null,"A1*",2335.9]
[null,"B ",2168.0700000000002]
[null,"B0",2117.3000000000002]
[null,"C ",1905.56]
[null,"C0",1606.49]
[null,"D ",1405.23]
[null,"E ",1067.02]
[null,"F ",1027.19]
[null,"G ",887.1]
[null,"H ",786.88]
[null,"I ",690.31]
[null,"J ",586.41999999999996]
[null,"K ",473.34999999999997]
[null,"L ",459.99]
[null,"M ",423.84999999999997]
[null,"M1*",373.27]
[null,"N ",345.90999999999997]
[null,"Ñ ",326.99]
[null,"O ",286.37]
[null,"P ",222.38]
[null,"Q ",164.51999999999998]
[null,"R ",152.31]
[null,"S ",135.54999999999998]
[null,"T ",108.98]
[null,"U ",94.37]
[null,"V ",44.28]
[]
[]
["2022-11-01"]
[null,null,null,"Grup",null,null,null,null,null,"Grup"]
[null,null,null,1,2,3,4,null,null,1,2,3,4]
["Sou base",null,null,2401.09,2090.21,1829.02,1514.8,null,"P.Perillositat",241.88,201.6,170.71,130.88]
["Millora",null,null,15.96,15.62,15.95,15.89,null,"Triennis",62.94,52.64,52.64,52.64]
["Acord Mesa universitats",null,null,7.74,7.74,7.74,7.74,null,"Hores extres",11.54,10.33,9.1199999999999992,7.6]
[]
["Complement de lloc de treball","A ",2680.21,null,2747.2152500000002]
[null,"A0",2490.4499999999998,null,2552.7112499999998]
[null,"A1*",2370.2600000000002,null,2429.5165000000002]
[null,"B ",2199.96,null,2254.9589999999998]
[null,"B0",2148.44,null,2202.1509999999998]
[null,"C ",1933.59,null,1981.92975]
[null,"C0",1630.12,null,1670.8729999999998]
[null,"D ",1425.9,null,1461.5475000000001]
[null,"E ",1082.72,null,1109.788]
[null,"F ",1042.3,null,1068.3574999999998]
[null,"G ",900.15,null,922.65374999999995]
[null,"H ",798.46,null,818.42150000000004]
[null,"I ",700.47,null,717.98175000000003]
[null,"J ",595.04999999999995,null,609.92624999999998]
[null,"K ",480.32,null,492.32799999999997]
[null,"L ",466.76,null,478.42899999999997]
[null,"M ",430.09,null,440.84224999999998]
[null,"M1*",378.76,null,388.22899999999998]
[null,"N ",351,null,359.77499999999998]
[null,"Ñ ",331.8,null,340.09500000000003]
[null,"O ",290.58999999999997,null,297.85474999999997]
[null,"P ",225.66,null,231.3015]
[null,"Q ",166.94,null,171.11349999999999]
[null,"R ",154.55000000000001,null,158.41375000000002]
[null,"S ",137.55000000000001,null,140.98875000000001]
[null,"T ",110.59,null,113.35475000000001]
[null,"U ",95.76,null,98.154000000000011]
[null,"V ",44.94,null,46.063499999999998]
[]
[]
[]
["2023-02-01",2.5000000000000001E-2]
[null,null,null,"Grup",null,null,null,null,null,"Grup"]
[null,null,null,1,2,3,4,null,null,1,2,3,4]
["Sou base",null,null,{"$f":"(D77*$B$112)+D77","v":2461.1172500000002},2142.4652500000002,1874.7455,1552.6699999999998,null,"P.Perillositat",{"$f":"(J77*$B$112)+J77","v":247.92699999999999},206.64,174.97775000000001,134.15199999999999]
["Millora",null,null,16.359000000000002,16.0105,16.348749999999999,16.28725,null,"Triennis",64.513499999999993,53.956000000000003,53.956000000000003,53.956000000000003]
["Acord Mesa universitats",null,null,{"$f":"(D79*$B$112)+D79","v":7.9335000000000004},7.9335000000000004,7.9335000000000004,7.9335000000000004,null,"Hores extres",11.54,10.33,9.1199999999999992,7.6]
[]
[]
[null,"A ",{"$f":"(C81*$B$112)+C81","v":2747.2152500000002}]
[null,"A0",{"$f":"(C82*$B$112)+C82","v":2552.7112499999998}]
[null,"A1*",{"$f":"(C83*$B$112)+C83","v":2429.5165000000002}]
[null,"B ",{"$f":"(C84*$B$112)+C84","v":2254.9589999999998}]
[null,"B0",2202.1509999999998]
[null,"C ",1981.92975]
[null,"C0",1670.8729999999998]
[null,"D ",1461.5475000000001]
[null,"E ",1109.788]
[null,"F ",1068.3574999999998]
[null,"G ",922.65374999999995]
[null,"H ",818.42150000000004]
[null,"I ",717.98175000000003]
[null,"J ",609.92624999999998]
[null,"K ",492.32799999999997]
[null,"L ",478.42899999999997]
[null,"M ",440.84224999999998]
[null,"M1*",388.22899999999998]
[null,"N ",359.77499999999998]
[null,"Ñ ",340.09500000000003]
[null,"O ",297.85474999999997]
[null,"P ",231.3015]
[null,"Q ",171.11349999999999]
[null,"R ",158.41375000000002]
[null,"S ",140.98875000000001]
[null,"T ",113.35475000000001]
[null,"U ",98.154000000000011]
[null,"V ",46.063499999999998]
[]
[]
[]
["2023-11-01",5.0000000000000001E-3,"(retroactiu gener-23)"]
[]
[]
[null,null,null,"Grup",null,null,null,null,null,"Grup"]
[null,null,null,1,2,3,4,null,null,1,2,3,4]
["Sou base",null,null,2473.13,2152.91,1883.9,1560.24,null,"P.Perillositat",249.13,207.64,176.15,134.81]
["Millora",null,null,16.440000000000001,16.09,16.43,16.37,null,"Triennis",64.819999999999993,54.21,54.21,54.21]
["Acord Mesa universitats",null,null,7.98,7.98,7.98,7.98,null,"Hores extres",11.54,10.33,9.1199999999999992,7.6]
[]
[]
[null,"A ",2760.62]
[null,"A0",2565.17]
[null,"A1*",2441.3700000000003]
[null,"B ",2265.9499999999998]
[null,"B0",2212.9]
[null,"C ",1991.59]
[null,"C0",1679.04]
[null,"D ",1468.68]
[null,"E ",1115.2]
[null,"F ",1073.57]
[null,"G ",927.15]
[null,"H ",822.42]
[null,"I ",721.48]
[null,"J ",612.91]
[null,"K ",494.72]
[null,"L ",480.77]
[null,"M ",442.99]
[null,"M1*",390.13]
[null,"N ",361.52]
[null,"Ñ ",341.75]
[null,"O ",299.3]
[null,"P ",232.42]
[null,"Q ",171.95]
[null,"R ",159.19]
[null,"S ",141.68]
[null,"T ",113.9]
[null,"U ",98.63]
[null,"V ",46.29]

{"sheet":"Vacances","index":4,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
["Càlcul dies de vacances"]
[]
["2024-04-01","Inici període. Ha de ser posterior o igual que el darrer 1 de setembre"]
["2024-07-31","Fi període. La data de finalització del contracte"]
[]
[0,"Dies d'absència en el període: Vagues, permisos sense sou, etc…"]
[]
[0,"Dies Gaudits de vacances en el període"]
[]
[{"$f":"ROUNDUP(((A5-A4-A7)*22/365)-A9,0)","v":8},"DIES QUE PERTOQUEN DE VACANCES"]
["DIES HABILS MIRAR SEMPRE CALENDARI"]
["1,8 DIES HÀBILS PER MES TREBALLAT. AIXÒ CORRESPON ALS 22 DIES HÀBILS PER ANY TREBALLAT."]

{"sheet":"calcul dies","index":5,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":true,"merged":[[22,4,22,13],[27,4,27,13],[0,0,0,13],[2,4,2,13],[7,4,7,13],[12,4,12,13],[17,4,17,13]]}
["CALCULS DIES LABORALS NO TOPATS"]
[]
["MERITACIÓ ARROSEGAMENT PAGUES LABORALS NO TOPATS",null,null,null,"CÀLCUL DIES VINVULACIÓ"]
[null,"DATA INICI","DATA FI",null,null,"DIA","MES ","ANY",null,"dif mesos","dif dies","total mesos","dies","total dies"]
["TOTAL VINCULACIÓ",{"$f":"'LABORALS '!B65","v":" "},{"$f":"'LABORALS '!G5","v":"2024-12-31"},null,"INICI VINCULACIÓ",{"$f":"DAY(B5)","v":{"$error":"#VALUE!"}},{"$f":"MONTH(B5)","v":{"$error":"#VALUE!"}},{"$f":"YEAR(B5)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(F5>1,-1,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(F5=1,-M5,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(H5=H6,G6-G5+1,13-G5+G6+(H6-H5-1)*12)+J5+J6","v":{"$error":"#VALUE!"}},{"$f":"IF(G5=1,31-F5,IF(G5=2,28-F5,IF(G5=3,31-F5,IF(G5=4,30-F5,IF(G5=5,31-F5,IF(G5=6,30-F5,IF(G5=7,31-F5,IF(G5=8,31-F5,IF(G5=9,30-F5,IF(G5=10,31-F5,IF(G5=11,30-F5,IF(G5=12,31-F5))))))))))))+1","v":{"$error":"#VALUE!"}},{"$f":"SUM(K5+M5+M6)","v":{"$error":"#VALUE!"}}]
["PRORROGA",{"$f":"'LABORALS '!B66","v":" "},{"$f":"'LABORALS '!G5","v":"2024-12-31"},null,"FI VINCULACIÓ",{"$f":"DAY(C5)","v":31},{"$f":"MONTH(C5)","v":12},{"$f":"YEAR(C5)","v":2024},null,{"$f":"IF(AND(G6=1,F6=31),0,IF(AND(G6=2,28=F6),0,IF(AND(G6=3,31=F6),0,IF(AND(G6=4,30=F6),0,IF(AND(G6=5,31=F6),0,IF(AND(G6=6,30=F6),0,IF(AND(G6=7,31=F6),0,IF(AND(G6=8,31=F6),0,IF(AND(G6=9,30=F6),0,IF(AND(G6=10,31=F6),0,IF(AND(G6=11,30=F6),0,IF(AND(G6=12,31=F6),0,-1))))))))))))","v":0},null,null,{"$f":"IF(AND(G6=1,F6<>31),F6,IF(AND(G6=2,28<>F6),F6,IF(AND(G6=3,31<>F6),F6,IF(AND(G6=4,30<>F6),F6,IF(AND(G6=5,31<>F6),F6,IF(AND(G6=6,30<>F6),F6,IF(AND(G6=7,31<>F6),F6,IF(AND(G6=8,31<>F6),F6,IF(AND(G6=9,30<>F6),F6,IF(AND(G6=10,31<>F6),F6,IF(AND(G6=11,30<>F6),F6,IF(AND(G6=12,31<>F6),F6,0))))))))))))","v":0}]
["MERITEN",null,"DATA FI"]
["de 01/07 a 30/06",{"$f":"'LABORALS '!B68","v":"00:00:00"},{"$f":"'LABORALS '!C68","v":"2024-12-30"},null,"CÀLCUL DIES PRÒRROGA"]
["de 01/01 a 31/12",{"$f":"'LABORALS '!B69","v":"00:00:00"},{"$f":"'LABORALS '!C69","v":"2024-12-30"},null,null,"DIA","MES ","ANY",null,"dif mesos","dif dies","total mesos","dies","total dies"]
["Indemnització RD",{"$f":"B5","v":" "},{"$f":"'LABORALS '!C70","v":"2024-12-30"},null,"INICI PRORROGA",{"$f":"DAY(B6)","v":{"$error":"#VALUE!"}},{"$f":"MONTH(B6)","v":{"$error":"#VALUE!"}},{"$f":"YEAR(B6)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(F10>1,-1,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(F10=1,-M10,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(H10=H11,G11-G10+1,13-G10+G11+(H11-H10-1)*12)+J10+J11","v":{"$error":"#VALUE!"}},{"$f":"IF(G10=1,31-F10,IF(G10=2,28-F10,IF(G10=3,31-F10,IF(G10=4,30-F10,IF(G10=5,31-F10,IF(G10=6,30-F10,IF(G10=7,31-F10,IF(G10=8,31-F10,IF(G10=9,30-F10,IF(G10=10,31-F10,IF(G10=11,30-F10,IF(G10=12,31-F10))))))))))))+1","v":{"$error":"#VALUE!"}},{"$f":"SUM(K10+M10+M11)","v":{"$error":"#VALUE!"}}]
["Període treballat al 2014",{"$f":"'LABORALS '!B71","v":"00:00:00"},{"$f":"'LABORALS '!C71","v":"2014-12-31"},null,"FI VINCULACIÓ",{"$f":"DAY(C5)","v":31},{"$f":"MONTH(C5)","v":12},{"$f":"YEAR(C5)","v":2024},null,{"$f":"IF(AND(G11=1,F11=31),0,IF(AND(G11=2,28=F11),0,IF(AND(G11=3,31=F11),0,IF(AND(G11=4,30=F11),0,IF(AND(G11=5,31=F11),0,IF(AND(G11=6,30=F11),0,IF(AND(G11=7,31=F11),0,IF(AND(G11=8,31=F11),0,IF(AND(G11=9,30=F11),0,IF(AND(G11=10,31=F11),0,IF(AND(G11=11,30=F11),0,IF(AND(G11=12,31=F11),0,-1))))))))))))","v":0},null,null,{"$f":"IF(AND(G11=1,F11<>31),F11,IF(AND(G11=2,28<>F11),F11,IF(AND(G11=3,31<>F11),F11,IF(AND(G11=4,30<>F11),F11,IF(AND(G11=5,31<>F11),F11,IF(AND(G11=6,30<>F11),F11,IF(AND(G11=7,31<>F11),F11,IF(AND(G11=8,31<>F11),F11,IF(AND(G11=9,30<>F11),F11,IF(AND(G11=10,31<>F11),F11,IF(AND(G11=11,30<>F11),F11,IF(AND(G11=12,31<>F11),F11,0))))))))))))","v":0}]
[]
[null,null,null,null,"MERITACIÓ PAGA JULIOL"]
[null,null,null,null,null,"DIA","MES ","ANY",null,"dif mesos","dif dies","total mesos","dies","total dies"]
[null,null,null,null,"INICI",{"$f":"DAY(B8)","v":0},{"$f":"MONTH(B8)","v":1},{"$f":"YEAR(B8)","v":1900},null,{"$f":"IF(F15>1,-1,0)","v":0},{"$f":"IF(F15=1,-M15,0)","v":0},{"$f":"IF(H15=H16,G16-G15+1,13-G15+G16+(H16-H15-1)*12)+J15+J16","v":1499},{"$f":"IF(G15=1,31-F15,IF(G15=2,28-F15,IF(G15=3,31-F15,IF(G15=4,30-F15,IF(G15=5,31-F15,IF(G15=6,30-F15,IF(G15=7,31-F15,IF(G15=8,31-F15,IF(G15=9,30-F15,IF(G15=10,31-F15,IF(G15=11,30-F15,IF(G15=12,31-F15))))))))))))+1","v":32},{"$f":"SUM(K15+M15+M16)","v":62}]
[null,null,null,null,"FI",{"$f":"DAY(C8)","v":30},{"$f":"MONTH(C8)","v":12},{"$f":"YEAR(C8)","v":2024},null,{"$f":"IF(AND(G16=1,F16=31),0,IF(AND(G16=2,28=F16),0,IF(AND(G16=3,31=F16),0,IF(AND(G16=4,30=F16),0,IF(AND(G16=5,31=F16),0,IF(AND(G16=6,30=F16),0,IF(AND(G16=7,31=F16),0,IF(AND(G16=8,31=F16),0,IF(AND(G16=9,30=F16),0,IF(AND(G16=10,31=F16),0,IF(AND(G16=11,30=F16),0,IF(AND(G16=12,31=F16),0,-1))))))))))))","v":-1},null,null,{"$f":"IF(AND(G16=1,F16<>31),F16,IF(AND(G16=2,28<>F16),F16,IF(AND(G16=3,31<>F16),F16,IF(AND(G16=4,30<>F16),F16,IF(AND(G16=5,31<>F16),F16,IF(AND(G16=6,30<>F16),F16,IF(AND(G16=7,31<>F16),F16,IF(AND(G16=8,31<>F16),F16,IF(AND(G16=9,30<>F16),F16,IF(AND(G16=10,31<>F16),F16,IF(AND(G16=11,30<>F16),F16,IF(AND(G16=12,31<>F16),F16,0))))))))))))","v":30}]
[]
[null,null,null,null,"MERITACIÓ PAGA DESEMBRE"]
[null,null,null,null,null,"DIA","MES ","ANY",null,"dif mesos","dif dies","total mesos","dies","total dies"]
[null,null,null,null,"INICI",{"$f":"DAY(B9)","v":0},{"$f":"MONTH(B9)","v":1},{"$f":"YEAR(B9)","v":1900},null,{"$f":"IF(F20>1,-1,0)","v":0},{"$f":"IF(F20=1,-M20,0)","v":0},{"$f":"IF(H20=H21,G21-G20+1,13-G20+G21+(H21-H20-1)*12)+J20+J21","v":1499},{"$f":"IF(G20=1,31-F20,IF(G20=2,28-F20,IF(G20=3,31-F20,IF(G20=4,30-F20,IF(G20=5,31-F20,IF(G20=6,30-F20,IF(G20=7,31-F20,IF(G20=8,31-F20,IF(G20=9,30-F20,IF(G20=10,31-F20,IF(G20=11,30-F20,IF(G20=12,31-F20))))))))))))+1","v":32},{"$f":"SUM(K20+M20+M21)","v":62}]
[null,null,null,null,"FI",{"$f":"DAY(C9)","v":30},{"$f":"MONTH(C9)","v":12},{"$f":"YEAR(C9)","v":2024},null,{"$f":"IF(AND(G21=1,F21=31),0,IF(AND(G21=2,28=F21),0,IF(AND(G21=3,31=F21),0,IF(AND(G21=4,30=F21),0,IF(AND(G21=5,31=F21),0,IF(AND(G21=6,30=F21),0,IF(AND(G21=7,31=F21),0,IF(AND(G21=8,31=F21),0,IF(AND(G21=9,30=F21),0,IF(AND(G21=10,31=F21),0,IF(AND(G21=11,30=F21),0,IF(AND(G21=12,31=F21),0,-1))))))))))))","v":-1},null,null,{"$f":"IF(AND(G21=1,F21<>31),F21,IF(AND(G21=2,28<>F21),F21,IF(AND(G21=3,31<>F21),F21,IF(AND(G21=4,30<>F21),F21,IF(AND(G21=5,31<>F21),F21,IF(AND(G21=6,30<>F21),F21,IF(AND(G21=7,31<>F21),F21,IF(AND(G21=8,31<>F21),F21,IF(AND(G21=9,30<>F21),F21,IF(AND(G21=10,31<>F21),F21,IF(AND(G21=11,30<>F21),F21,IF(AND(G21=12,31<>F21),F21,0))))))))))))","v":30}]
[]
[null,null,null,null,"CÀLCUL DIES INDEMNITZACIÓ"]
[null,null,null,null,null,"DIA","MES ","ANY",null,"dif mesos","dif dies","total mesos","dies","total dies"]
[null,null,null,null,"INICI",{"$f":"DAY(B10)","v":{"$error":"#VALUE!"}},{"$f":"MONTH(B10)","v":{"$error":"#VALUE!"}},{"$f":"YEAR(B10)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(F25>1,-1,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(F25=1,-M25,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(H25=H26,G26-G25+1,13-G25+G26+(H26-H25-1)*12)+J25+J26","v":{"$error":"#VALUE!"}},{"$f":"IF(G25=1,31-F25,IF(G25=2,28-F25,IF(G25=3,31-F25,IF(G25=4,30-F25,IF(G25=5,31-F25,IF(G25=6,30-F25,IF(G25=7,31-F25,IF(G25=8,31-F25,IF(G25=9,30-F25,IF(G25=10,31-F25,IF(G25=11,30-F25,IF(G25=12,31-F25))))))))))))+1","v":{"$error":"#VALUE!"}},{"$f":"SUM(K25+M25+M26)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"FI",{"$f":"DAY(C10)","v":30},{"$f":"MONTH(C10)","v":12},{"$f":"YEAR(C10)","v":2024},null,{"$f":"IF(AND(G26=1,F26=31),0,IF(AND(G26=2,28=F26),0,IF(AND(G26=3,31=F26),0,IF(AND(G26=4,30=F26),0,IF(AND(G26=5,31=F26),0,IF(AND(G26=6,30=F26),0,IF(AND(G26=7,31=F26),0,IF(AND(G26=8,31=F26),0,IF(AND(G26=9,30=F26),0,IF(AND(G26=10,31=F26),0,IF(AND(G26=11,30=F26),0,IF(AND(G26=12,31=F26),0,-1))))))))))))","v":-1},null,null,{"$f":"IF(AND(G26=1,F26<>31),F26,IF(AND(G26=2,28<>F26),F26,IF(AND(G26=3,31<>F26),F26,IF(AND(G26=4,30<>F26),F26,IF(AND(G26=5,31<>F26),F26,IF(AND(G26=6,30<>F26),F26,IF(AND(G26=7,31<>F26),F26,IF(AND(G26=8,31<>F26),F26,IF(AND(G26=9,30<>F26),F26,IF(AND(G26=10,31<>F26),F26,IF(AND(G26=11,30<>F26),F26,IF(AND(G26=12,31<>F26),F26,0))))))))))))","v":30}]
[]
[null,null,null,null,"CÀLCUL DIES RETALLADA"]
[null,null,null,null,null,"DIA","MES ","ANY",null,"dif mesos","dif dies","total mesos","dies","total dies"]
[null,null,null,null,"INICI",{"$f":"DAY(B11)","v":0},{"$f":"MONTH(B11)","v":1},{"$f":"YEAR(B11)","v":1900},null,{"$f":"IF(F30>1,-1,0)","v":0},{"$f":"IF(F30=1,-M30,0)","v":0},{"$f":"IF(H30=H31,G31-G30+1,13-G30+G31+(H31-H30-1)*12)+J30+J31","v":1380},{"$f":"IF(G30=1,31-F30,IF(G30=2,28-F30,IF(G30=3,31-F30,IF(G30=4,30-F30,IF(G30=5,31-F30,IF(G30=6,30-F30,IF(G30=7,31-F30,IF(G30=8,31-F30,IF(G30=9,30-F30,IF(G30=10,31-F30,IF(G30=11,30-F30,IF(G30=12,31-F30))))))))))))+1","v":32},{"$f":"SUM(K30+M30+M31)","v":32}]
[null,null,null,null,"FI",{"$f":"DAY(C11)","v":31},{"$f":"MONTH(C11)","v":12},{"$f":"YEAR(C11)","v":2014},null,{"$f":"IF(AND(G31=1,F31=31),0,IF(AND(G31=2,28=F31),0,IF(AND(G31=3,31=F31),0,IF(AND(G31=4,30=F31),0,IF(AND(G31=5,31=F31),0,IF(AND(G31=6,30=F31),0,IF(AND(G31=7,31=F31),0,IF(AND(G31=8,31=F31),0,IF(AND(G31=9,30=F31),0,IF(AND(G31=10,31=F31),0,IF(AND(G31=11,30=F31),0,IF(AND(G31=12,31=F31),0,-1))))))))))))","v":0},null,null,{"$f":"IF(AND(G31=1,F31<>31),F31,IF(AND(G31=2,28<>F31),F31,IF(AND(G31=3,31<>F31),F31,IF(AND(G31=4,30<>F31),F31,IF(AND(G31=5,31<>F31),F31,IF(AND(G31=6,30<>F31),F31,IF(AND(G31=7,31<>F31),F31,IF(AND(G31=8,31<>F31),F31,IF(AND(G31=9,30<>F31),F31,IF(AND(G31=10,31<>F31),F31,IF(AND(G31=11,30<>F31),F31,IF(AND(G31=12,31<>F31),F31,0))))))))))))","v":0}]